
     data FINAL_GAM_MODELDATA    ;
     %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
     infile 'D:\Amazon Price Dynamics\New Data\GAM + MVRF\Other categories\Deep Fryers\final_gam_modeldata_deepfryer.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2;
        informat TIME best32. ;
        informat Y_amzn_csnart_lag1 best32. ;
        informat Y_amzn_csnart_lag2 best32. ;
        informat Y_amzn_csnart_lag3 best32. ;
        informat Y_amzn_hbeach_lag1 best32. ;
        informat Y_amzn_hbeach_lag2 best32. ;
        informat Y_amzn_hbeach_lag3 best32. ;
        informat Y_amzn_presto_lag1 best32. ;
        informat Y_amzn_presto_lag2 best32. ;
        informat Y_amzn_presto_lag3 best32. ;
        informat Y_amzn_tfal_lag1 best32. ;
        informat Y_amzn_tfal_lag2 best32. ;
        informat Y_amzn_tfal_lag3 best32. ;
        informat Y_clust1_csnart_lag1 best32. ;
        informat Y_clust1_csnart_lag2 best32. ;
        informat Y_clust1_csnart_lag3 best32. ;
        informat Y_clust2_tfal_lag1 best32. ;
        informat Y_clust2_tfal_lag2 best32. ;
        informat Y_clust2_tfal_lag3 best32. ;
        informat Y_clust3_csnart_lag1 best32. ;
        informat Y_clust3_csnart_lag2 best32. ;
        informat Y_clust3_csnart_lag3 best32. ;
        informat Y_clust4_secura_lag1 best32. ;
        informat Y_clust4_secura_lag2 best32. ;
        informat Y_clust4_secura_lag3 best32. ;
        informat Y_clust5_tfal_lag1 best32. ;
        informat Y_clust5_tfal_lag2 best32. ;
        informat Y_clust5_tfal_lag3 best32. ;
        informat Answered_QuestionsEP_lag1 best32. ;
        informat Answered_QuestionsHbeach_lag1 best32. ;
        informat Answered_Questionscsnart_lag1 best32. ;
        informat Answered_Questionssecura_lag1 best32. ;
        informat Answered_Questionstfal_lag1 best32. ;
        informat FBA_used3p_lag1 best32. ;
        informat Freeship_amzn_lag1 best32. ;
        informat Freeship_used3p_lag1 best32. ;
        informat Freeship_usedamzn_lag1 best32. ;
        informat nonbbox3pprice_EP_lag best32. ;
        informat nonbbox3pprice_Hbeach_lag best32. ;
        informat nonbbox3pprice_csnart_lag best32. ;
        informat nonbbox3pprice_secura_lag best32. ;
        informat nonbbox3pprice_tfal_lag best32. ;
        informat NUM_SELLERSamzn_lag1 best32. ;
        informat NUM_SELLERSclust1_lag1 best32. ;
        informat NUM_SELLERSclust2_lag1 best32. ;
        informat NUM_SELLERSclust3_lag1 best32. ;
        informat NUM_SELLERSclust4_lag1 best32. ;
        informat NUM_SELLERSclust5_lag1 best32. ;
        informat NUM_SELLERSused3p_lag1 best32. ;
        informat NUM_SELLERSusedamzn_lag1 best32. ;
        informat NUM_SKUSamzn_lag1 best32. ;
        informat NUM_SKUSclust1_lag1 best32. ;
        informat NUM_SKUSclust2_lag1 best32. ;
        informat NUM_SKUSclust3_lag1 best32. ;
        informat NUM_SKUSclust4_lag1 best32. ;
        informat NUM_SKUSclust5_lag1 best32. ;
        informat NUM_SKUSused3p_lag1 best32. ;
        informat NUM_SKUSusedamzn_lag1 best32. ;
        informat NUM_prestoamzn_lag1 best32. ;
        informat NUM_prestoclust1_lag1 best32. ;
        informat NUM_prestoclust2_lag1 best32. ;
        informat NUM_prestoclust3_lag1 best32. ;
        informat NUM_prestoclust4_lag1 best32. ;
        informat NUM_prestoclust5_lag1 best32. ;
        informat NUM_prestoused3p_lag1 best32. ;
        informat NUM_prestousedamzn_lag1 best32. ;
        informat Product_reviews_EP_lag1 best32. ;
        informat Product_reviews_Hbeach_lag1 best32. ;
        informat Product_reviews_csnart_lag1 best32. ;
        informat Product_reviews_secura_lag1 best32. ;
        informat Product_reviews_tfal_lag1 best32. ;
        informat salerank_EP_lag1 best32. ;
        informat salerank_Hbeach_lag1 best32. ;
        informat salerank_csnart_lag1 best32. ;
        informat salerank_secura_lag1 best32. ;
        informat salerank_tfal_lag1 best32. ;
        informat saleranksubcat_EP_lag1 best32. ;
        informat saleranksubcat_Hbeach_lag1 best32. ;
        informat saleranksubcat_csnart_lag1 best32. ;
        informat saleranksubcat_secura_lag1 best32. ;
        informat saleranksubcat_tfal_lag1 best32. ;
        informat buyboxprice_EP_lag1 best32. ;
        informat buyboxprice_Hbeach_lag1 best32. ;
        informat buyboxprice_csnart_lag1 best32. ;
        informat buyboxprice_secura_lag1 best32. ;
        informat buyboxprice_tfal_lag1 best32. ;
        informat cumsalefreq_amzn_lag1 best32. ;
        informat max_Product_reviews_presto_lag1 best32. ;
        informat max_ans_questions_presto_lag1 best32. ;
        informat max_buyboxprice_presto_lag1 best32. ;
        informat max_cumsalefreq_clust1_lag1 best32. ;
        informat max_cumsalefreq_clust2_lag1 best32. ;
        informat max_cumsalefreq_clust3_lag1 best32. ;
        informat max_cumsalefreq_clust4_lag1 best32. ;
        informat max_cumsalefreq_clust5_lag1 best32. ;
        informat maxnumsellerrate_clust1_lag1 best32. ;
        informat maxnumsellerate_clust2_lag1 best32. ;
        informat maxnumsellerate_clust3_lag1 best32. ;
        informat maxnumsellerate_clust4_lag1 best32. ;
        informat maxnumsellerate_clust5_lag1 best32. ;
        informat maxpercsellerate_clust1_lag1 best32. ;
        informat maxpercsellerate_clust2_lag1 best32. ;
        informat maxpercsellerate_clust3_lag1 best32. ;
        informat maxpercsellerate_clust4_lag1 best32. ;
        informat maxpercsellerate_clust5_lag1 best32. ;
        informat maxprodstar_presto_lag1 best32. ;
        informat maxsalerank_presto_lag1 best32. ;
        informat maxsaleranksubcat_presto_lag1 best32. ;
        informat maxsellerstar_clust1_lag1 best32. ;
        informat maxsellerstar_clust2_lag1 best32. ;
        informat maxsellerstar_clust3_lag1 best32. ;
        informat maxsellerstar_clust4_lag1 best32. ;
        informat maxsellerstar_clust5_lag1 best32. ;
        informat max_uniq_ASIN_clust1_lag1 best32. ;
        informat max_uniq_ASIN_clust2_lag1 best32. ;
        informat max_uniq_ASIN_clust3_lag1 best32. ;
        informat max_uniq_ASIN_clust4_lag1 best32. ;
        informat max_uniq_ASIN_clust5_lag1 best32. ;
        informat mean_Product_reviews_presto_lag1 best32. ;
        informat mean_ans_questions_presto_lag1 best32. ;
        informat mean_buyboxprice_presto_lag1 best32. ;
        informat mean_nonbbox3p_presto_lag best32. ;
        informat mean_cumsalefreq_clust1_lag1 best32. ;
        informat mean_cumsalefreq_clust2_lag1 best32. ;
        informat mean_cumsalefreq_clust3_lag1 best32. ;
        informat mean_cumsalefreq_clust4_lag1 best32. ;
        informat mean_cumsalefreq_clust5_lag1 best32. ;
        informat meannumsellerate_clust1_lag1 best32. ;
        informat meannumsellerate_clust2_lag1 best32. ;
        informat meannumsellerate_clust3_lag1 best32. ;
        informat meannumsellerate_clust4_lag1 best32. ;
        informat meannumsellerate_clust5_lag1 best32. ;
        informat meanpercsellerate_clust1_lag1 best32. ;
        informat meanpercsellerate_clust2_lag1 best32. ;
        informat meanpercsellerate_clust3_lag1 best32. ;
        informat meanpercsellerate_clust4_lag1 best32. ;
        informat meanpercsellerate_clust5_lag1 best32. ;
        informat meanprodstar_presto_lag1 best32. ;
        informat meansalerank_presto_lag1 best32. ;
        informat meansaleranksubcat_presto_lag1 best32. ;
        informat meansellerstar_clust1_lag1 best32. ;
        informat meansellerstar_clust2_lag1 best32. ;
        informat meansellerstar_clust3_lag1 best32. ;
        informat meansellerstar_clust4_lag1 best32. ;
        informat meansellerstar_clust5_lag1 best32. ;
        informat mean_uniq_ASIN_clust1_lag1 best32. ;
        informat mean_uniq_ASIN_clust2_lag1 best32. ;
        informat mean_uniq_ASIN_clust3_lag1 best32. ;
        informat mean_uniq_ASIN_clust4_lag1 best32. ;
        informat mean_uniq_ASIN_clust5_lag1 best32. ;
        informat min_Product_reviews_presto_lag1 best32. ;
        informat min_ans_questions_presto_lag1 best32. ;
        informat min_buyboxprice_presto_lag1 best32. ;
        informat min_cumsalefreq_clust1_lag1 best32. ;
        informat min_cumsalefreq_clust2_lag1 best32. ;
        informat min_cumsalefreq_clust3_lag1 best32. ;
        informat min_cumsalefreq_clust4_lag1 best32. ;
        informat min_cumsalefreq_clust5_lag1 best32. ;
        informat minnumsellerate_clust1_lag1 best32. ;
        informat minnumsellerate_clust2_lag1 best32. ;
        informat minnumsellerate_clust3_lag1 best32. ;
        informat minnumsellerate_clust4_lag1 best32. ;
        informat minnumsellerate_clust5_lag1 best32. ;
        informat minpercsellerate_clust1_lag1 best32. ;
        informat minpercsellerate_clust2_lag1 best32. ;
        informat minpercsellerate_clust3_lag1 best32. ;
        informat minpercsellerate_clust4_lag1 best32. ;
        informat minpercsellerate_clust5_lag1 best32. ;
        informat minproductstar_presto_lag1 best32. ;
        informat minsalerank_presto_lag1 best32. ;
        informat minsaleranksubcat_presto_lag1 best32. ;
        informat minsellerstar_clust1_lag1 best32. ;
        informat minsellerstar_clust2_lag1 best32. ;
        informat minsellerstar_clust3_lag1 best32. ;
        informat minsellerstar_clust4_lag1 best32. ;
        informat minsellerstar_clust5_lag1 best32. ;
        informat min_uniq_ASIN_clust1_lag1 best32. ;
        informat min_uniq_ASIN_clust2_lag1 best32. ;
        informat min_uniq_ASIN_clust3_lag1 best32. ;
        informat min_uniq_ASIN_clust4_lag1 best32. ;
        informat min_uniq_ASIN_clust5_lag1 best32. ;
        informat num_EPamzn_lag1 best32. ;
        informat num_EPclust1_lag1 best32. ;
        informat num_EPclust2_lag1 best32. ;
        informat num_EPclust3_lag1 best32. ;
        informat num_EPclust4_lag1 best32. ;
        informat num_EPclust5_lag1 best32. ;
        informat num_EPused3p_lag1 best32. ;
        informat num_EPusedamzn_lag1 best32. ;
        informat num_FBA_clust1_lag1 best32. ;
        informat num_FBA_clust2_lag1 best32. ;
        informat num_FBA_clust3_lag1 best32. ;
        informat num_FBA_clust4_lag1 best32. ;
        informat num_FBA_clust5_lag1 best32. ;
        informat num_Freeship_clust1_lag1 best32. ;
        informat num_Freeship_clust2_lag1 best32. ;
        informat num_Freeship_clust3_lag1 best32. ;
        informat num_Freeship_clust4_lag1 best32. ;
        informat num_Freeship_clust5_lag1 best32. ;
        informat num_HBeachamzn_lag1 best32. ;
        informat num_HBeachclust1_lag1 best32. ;
        informat num_HBeachclust2_lag1 best32. ;
        informat num_HBeachclust3_lag1 best32. ;
        informat num_HBeachclust4_lag1 best32. ;
        informat num_HBeachclust5_lag1 best32. ;
        informat num_HBeachused3p_lag1 best32. ;
        informat num_HBeachusedamzn_lag1 best32. ;
        informat num_csnartamzn_lag1 best32. ;
        informat num_csnartclust1_lag1 best32. ;
        informat num_csnartclust2_lag1 best32. ;
        informat num_csnartclust3_lag1 best32. ;
        informat num_csnartclust4_lag1 best32. ;
        informat num_csnartclust5_lag1 best32. ;
        informat num_csnartused3p_lag1 best32. ;
        informat num_csnartusedamzn_lag1 best32. ;
        informat pricechangeEPamzn_lag1 best32. ;
        informat pricechangeEPclust1_lag1 best32. ;
        informat pricechangeEPclust2_lag1 best32. ;
        informat pricechangeEPclust3_lag1 best32. ;
        informat pricechangeEPclust4_lag1 best32. ;
        informat pricechangeEPclust5_lag1 best32. ;
        informat pricechangeEPused3p_lag1 best32. ;
        informat pricechangeEPusedamzn_lag1 best32. ;
        informat pricechangeHbeachamzn_lag1 best32. ;
        informat pricechangeHbeachclust1_lag1 best32. ;
        informat pricechangeHbeachclust2_lag1 best32. ;
        informat pricechangeHbeachclust3_lag1 best32. ;
        informat pricechangeHbeachclust4_lag1 best32. ;
        informat pricechangeHbeachclust5_lag1 best32. ;
        informat pricechangeHbeachused3p_lag1 best32. ;
        informat pricechangeHbeachusedamzn_lag1 best32. ;
        informat pricechangecsnartamzn_lag1 best32. ;
        informat pricechangecsnartclust1_lag1 best32. ;
        informat pricechangecsnartclust2_lag1 best32. ;
        informat pricechangecsnartclust3_lag1 best32. ;
        informat pricechangecsnartclust4_lag1 best32. ;
        informat pricechangecsnartclust5_lag1 best32. ;
        informat pricechangecsnartused3p_lag1 best32. ;
        informat pricechangecsnartusedamzn_lag1 best32. ;
        informat pricechangeprestoamzn_lag1 best32. ;
        informat pricechangeprestoclust1_lag1 best32. ;
        informat pricechangeprestoclust2_lag1 best32. ;
        informat pricechangeprestoclust3_lag1 best32. ;
        informat pricechangeprestoclust4_lag1 best32. ;
        informat pricechangeprestoclust5_lag1 best32. ;
        informat pricechangeprestoused3p_lag1 best32. ;
        informat pricechangeprestousedamzn_lag1 best32. ;
        informat pricechangesecuraamzn_lag1 best32. ;
        informat pricechangesecuraclust1_lag1 best32. ;
        informat pricechangesecuraclust2_lag1 best32. ;
        informat pricechangesecuraclust3_lag1 best32. ;
        informat pricechangesecuraclust4_lag1 best32. ;
        informat pricechangesecuraclust5_lag1 best32. ;
        informat pricechangesecuraused3p_lag1 best32. ;
        informat pricechangesecurausedamzn_lag1 best32. ;
        informat pricechangetfalamzn_lag1 best32. ;
        informat pricechangetfalclust1_lag1 best32. ;
        informat pricechangetfalclust2_lag1 best32. ;
        informat pricechangetfalclust3_lag1 best32. ;
        informat pricechangetfalclust4_lag1 best32. ;
        informat pricechangetfalclust5_lag1 best32. ;
        informat pricechangetfalused3p_lag1 best32. ;
        informat pricechangetfalusedamzn_lag1 best32. ;
        informat num_securaamzn_lag1 best32. ;
        informat num_securaclust1_lag1 best32. ;
        informat num_securaclust2_lag1 best32. ;
        informat num_securaclust3_lag1 best32. ;
        informat num_securaclust4_lag1 best32. ;
        informat num_securaclust5_lag1 best32. ;
        informat num_securaused3p_lag1 best32. ;
        informat num_securausedamzn_lag1 best32. ;
        informat num_tfalamzn_lag1 best32. ;
        informat num_tfalclust1_lag1 best32. ;
        informat num_tfalclust2_lag1 best32. ;
        informat num_tfalclust3_lag1 best32. ;
        informat num_tfalclust4_lag1 best32. ;
        informat num_tfalclust5_lag1 best32. ;
        informat num_tfalused3p_lag1 best32. ;
        informat num_tfalusedamzn_lag1 best32. ;
        informat priceAmzn_Hbeach_lag best32. ;
        informat priceAmzn_csnart_lag best32. ;
        informat priceAmzn_presto_lag best32. ;
        informat priceAmzn_tfal_lag best32. ;
        informat priceclust1_csnart_lag best32. ;
        informat priceclust2_tfal_lag best32.;
        informat priceclust3_csnart_lag best32. ;
        informat priceclust4_secura_lag best32. ;
        informat priceclust5_tfal_lag best32. ;
        informat pricedifflowst_AmznHbeach_lag best32. ;
        informat pricedifflowst_Amzncsnart_lag best32. ;
        informat pricedifflowst_Amznpresto_lag best32. ;
        informat pricedifflowst_Amzntfal_lag best32. ;
        informat pricedifflowst_clust1csnart_lag best32. ;
        informat pricedifflowst_clust2tfal_lag best32. ;
        informat pricedifflowst_clust3csn_lag best32. ;
        informat pricedifflowst_clust4sec_lag best32. ;
        informat pricedifflowst_clust5tfal_lag best32. ;
        informat productstar_EP_lag1 best32. ;
        informat productstar_Hbeach_lag1 best32. ;
        informat productstar_csnart_lag1 best32. ;
        informat productstar_secura_lag1 best32. ;
        informat productstar_tfal_lag1 best32. ;
        informat time1 mmddyy10. ;
        informat priceAmzn_tfal best32. ;
        informat pricediff_lowst_Amzn_tfal best32. ;
        informat Y_amzn_tfal best32. ;
        informat priceAmzn_Hbeach best32. ;
        informat pricediff_lowst_Amzn_Hbeach best32. ;
        informat Y_amzn_hbeach best32. ;
        informat priceAmzn_presto best32. ;
        informat pricediff_lowst_Amzn_presto best32. ;
        informat Y_amzn_presto best32. ;
        informat priceAmzn_csnart best32. ;
        informat pricediff_lowst_Amzn_csnart best32. ;
        informat Y_amzn_csnart best32. ;
        informat priceclust1_csnart best32. ;
        informat pricediff_lowst_clust1_csnart best32. ;
        informat Y_clust1_csnart best32. ;
        informat priceclust2_tfal best32. ;
        informat pricediff_lowst_clust2_tfal best32. ;
        informat Y_clust2_tfal best32. ;
        informat priceclust3_csnart best32. ;
        informat pricediff_lowst_clust3_csnart best32. ;
        informat Y_clust3_csnart best32. ;
        informat priceclust4_secura best32. ;
        informat pricediff_lowst_clust4_secura best32. ;
        informat Y_clust4_secura best32. ;
        informat priceclust5_tfal best32. ;
        informat pricediff_lowst_clust5_tfal best32.;
        informat Y_clust5_tfal best32. ;
        informat Freeship_amzn best32. ;
        informat cumsalefreq_amzn best32. ;
        informat Freeship_usedamzn best32. ;
        informat FBA_used3p best32. ;
        informat Freeship_used3p best32. ;
        informat num_FBA_clust1 best32. ;
        informat num_Freeship_clust1 best32. ;
        informat max_perct_sellerrating_clust1 best32. ;
        informat mean_perct_sellerrating_clust1 best32. ;
        informat min_perct_sellerrating_clust1 best32. ;
        informat max_num_seller_rating_clust1 best32. ;
        informat mean_num_seller_rating_clust1 best32. ;
        informat min_num_seller_rating_clust1 best32. ;
        informat max_seller_star_rating_clust1 best32. ;
        informat mean_seller_star_rating_clust1 best32. ;
        informat min_seller_star_rating_clust1 best32. ;
        informat max_uniq_ASIN_clust1 best32. ;
        informat mean_uniq_ASIN_clust1 best32. ;
        informat min_uniq_ASIN_clust1 best32. ;
        informat max_cumsalefreq_clust1 best32. ;
        informat mean_cumsalefreq_clust1 best32. ;
        informat min_cumsalefreq_clust1 best32. ;
        informat num_FBA_clust2 best32. ;
        informat num_Freeship_clust2 best32. ;
        informat max_perct_sellerrating_clust2 best32. ;
        informat mean_perct_sellerrating_clust2 best32. ;
        informat min_perct_sellerrating_clust2 best32. ;
        informat max_num_seller_rating_clust2 best32. ;
        informat mean_num_seller_rating_clust2 best32. ;
        informat min_num_seller_rating_clust2 best32. ;
        informat max_seller_star_rating_clust2 best32. ;
        informat mean_seller_star_rating_clust2 best32. ;
        informat min_seller_star_rating_clust2 best32. ;
        informat max_uniq_ASIN_clust2 best32. ;
        informat mean_uniq_ASIN_clust2 best32. ;
        informat min_uniq_ASIN_clust2 best32. ;
        informat max_cumsalefreq_clust2 best32. ;
        informat mean_cumsalefreq_clust2 best32. ;
        informat min_cumsalefreq_clust2 best32. ;
        informat num_FBA_clust3 best32. ;
        informat num_Freeship_clust3 best32. ;
        informat max_perct_sellerrating_clust3 best32. ;
        informat mean_perct_sellerrating_clust3 best32. ;
        informat min_perct_sellerrating_clust3 best32. ;
        informat max_num_seller_rating_clust3 best32. ;
        informat mean_num_seller_rating_clust3 best32. ;
        informat min_num_seller_rating_clust3 best32. ;
        informat max_seller_star_rating_clust3 best32. ;
        informat mean_seller_star_rating_clust3 best32. ;
        informat min_seller_star_rating_clust3 best32. ;
        informat max_uniq_ASIN_clust3 best32. ;
        informat mean_uniq_ASIN_clust3 best32. ;
        informat min_uniq_ASIN_clust3 best32. ;
        informat max_cumsalefreq_clust3 best32. ;
        informat mean_cumsalefreq_clust3 best32. ;
        informat min_cumsalefreq_clust3 best32. ;
        informat num_FBA_clust4 best32. ;
        informat num_Freeship_clust4 best32. ;
        informat max_perct_sellerrating_clust4 best32. ;
        informat mean_perct_sellerrating_clust4 best32. ;
        informat min_perct_sellerrating_clust4 best32. ;
        informat max_num_seller_rating_clust4 best32. ;
        informat mean_num_seller_rating_clust4 best32. ;
        informat min_num_seller_rating_clust4 best32. ;
        informat max_seller_star_rating_clust4 best32. ;
        informat mean_seller_star_rating_clust4 best32. ;
        informat min_seller_star_rating_clust4 best32. ;
        informat max_uniq_ASIN_clust4 best32. ;
        informat mean_uniq_ASIN_clust4 best32. ;
        informat min_uniq_ASIN_clust4 best32. ;
        informat max_cumsalefreq_clust4 best32. ;
        informat mean_cumsalefreq_clust4 best32. ;
        informat min_cumsalefreq_clust4 best32. ;
        informat num_FBA_clust5 best32. ;
        informat num_Freeship_clust5 best32. ;
        informat max_perct_sellerrating_clust5 best32. ;
        informat mean_perct_sellerrating_clust5 best32. ;
        informat min_perct_sellerrating_clust5 best32. ;
        informat max_num_seller_rating_clust5 best32. ;
        informat mean_num_seller_rating_clust5 best32. ;
        informat min_num_seller_rating_clust5 best32. ;
        informat max_seller_star_rating_clust5 best32. ;
        informat mean_seller_star_rating_clust5 best32. ;
        informat min_seller_star_rating_clust5 best32. ;
        informat max_uniq_ASIN_clust5 best32. ;
        informat mean_uniq_ASIN_clust5 best32. ;
        informat min_uniq_ASIN_clust5 best32. ;
        informat max_cumsalefreq_clust5 best32. ;
        informat mean_cumsalefreq_clust5 best32. ;
        informat min_cumsalefreq_clust5 best32. ;
        informat max_ans_questions_presto best32. ;
        informat mean_ans_questions_presto best32. ;
        informat min_ans_questions_presto best32. ;
        informat max_buyboxprice_presto best32. ;
        informat mean_buyboxprice_presto best32. ;
        informat min_buyboxprice_presto best32. ;
        informat max_nonbbox3pprice_presto best32. ;
        informat mean_nonbbox3pprice_presto best32. ;
        informat min_nonbbox3pprice_presto best32. ;
        informat max_product_star_rate_presto best32. ;
        informat mean_product_star_rate_presto best32. ;
        informat min_product_star_rate_presto best32. ;
        informat max_Product_reviews_presto best32. ;
        informat mean_Product_reviews_presto best32. ;
        informat min_Product_reviews_presto best32. ;
        informat max_salesrank_categ_presto best32. ;
        informat mean_salesrank_categ_presto best32. ;
        informat min_salesrank_categ_presto best32. ;
        informat max_salesrank_subcateg_presto best32. ;
        informat mean_salesrank_subcateg_presto best32. ;
        informat min_salesrank_subcateg_presto best32. ;
        informat NUM_SELLERSused3p best32. ;
        informat NUM_SKUSused3p best32. ;
        informat NUM_prestoused3p best32. ;
        informat num_securaused3p best32. ;
        informat num_EPused3p best32. ;
        informat num_HBeachused3p best32. ;
        informat num_tfalused3p best32. ;
        informat num_csnartused3p best32. ;
        informat NUM_SELLERSusedamzn best32. ;
        informat NUM_SKUSusedamzn best32. ;
        informat NUM_prestousedamzn best32. ;
        informat num_securausedamzn best32. ;
        informat num_EPusedamzn best32. ;
        informat num_HBeachusedamzn best32. ;
        informat num_tfalusedamzn best32. ;
        informat num_csnartusedamzn best32. ;
        informat NUM_SELLERSamzn best32. ;
        informat NUM_SKUSamzn best32. ;
        informat NUM_prestoamzn best32. ;
        informat num_securaamzn best32. ;
        informat num_EPamzn best32. ;
        informat num_HBeachamzn best32. ;
        informat num_tfalamzn best32. ;
        informat num_csnartamzn best32. ;
        informat NUM_SELLERSclust1 best32. ;
        informat NUM_SKUSclust1 best32. ;
        informat NUM_prestoclust1 best32. ;
        informat num_securaclust1 best32. ;
        informat num_EPclust1 best32. ;
        informat num_HBeachclust1 best32. ;
        informat num_tfalclust1 best32. ;
        informat num_csnartclust1 best32. ;
        informat NUM_SELLERSclust2 best32. ;
        informat NUM_SKUSclust2 best32. ;
        informat NUM_prestoclust2 best32. ;
        informat num_securaclust2 best32. ;
        informat num_EPclust2 best32. ;
        informat num_HBeachclust2 best32. ;
        informat num_tfalclust2 best32. ;
        informat num_csnartclust2 best32. ;
        informat NUM_SELLERSclust3 best32. ;
        informat NUM_SKUSclust3 best32. ;
        informat NUM_prestoclust3 best32. ;
        informat num_securaclust3 best32. ;
        informat num_EPclust3 best32. ;
        informat num_HBeachclust3 best32. ;
        informat num_tfalclust3 best32. ;
        informat num_csnartclust3 best32. ;
        informat NUM_SELLERSclust4 best32. ;
        informat NUM_SKUSclust4 best32. ;
        informat NUM_prestoclust4 best32. ;
        informat num_securaclust4 best32. ;
        informat num_EPclust4 best32. ;
        informat num_HBeachclust4 best32. ;
        informat num_tfalclust4 best32. ;
        informat num_csnartclust4 best32. ;
        informat NUM_SELLERSclust5 best32. ;
        informat NUM_SKUSclust5 best32. ;
        informat NUM_prestoclust5 best32. ;
        informat num_securaclust5 best32. ;
        informat num_EPclust5 best32. ;
        informat num_HBeachclust5 best32. ;
        informat num_tfalclust5 best32. ;
        informat num_csnartclust5 best32. ;
        informat buyboxprice_secura best32. ;
        informat product_star_secura best32. ;
        informat Sales_Rank_Own_Categ_secura best32. ;
        informat Sales_Rank_Sub_categ_secura best32. ;
        informat Answered_Questionssecura best32. ;
        informat Product_reviews_secura best32. ;
        informat nonbbox3pprice_secura best32. ;
        informat buyboxprice_EP best32. ;
        informat product_star_EP best32. ;
        informat Sales_Rank_Own_Categ_EP best32. ;
        informat Sales_Rank_Sub_categ_EP best32. ;
        informat Answered_QuestionsEP best32. ;
        informat Product_reviews_EP best32. ;
        informat nonbbox3pprice_EP best32. ;
        informat buyboxprice_Hbeach best32. ;
        informat product_star_Hbeach best32. ;
        informat Sales_Rank_Own_Categ_Hbeach best32. ;
        informat Sales_Rank_Sub_categ_Hbeach best32. ;
        informat Answered_QuestionsHbeach best32. ;
        informat Product_reviews_Hbeach best32. ;
        informat nonbbox3pprice_Hbeach best32. ;
        informat buyboxprice_tfal best32. ;
        informat product_star_tfal best32. ;
        informat Sales_Rank_Own_Categ_tfal best32. ;
        informat Sales_Rank_Sub_categ_tfal best32. ;
        informat Answered_Questionstfal best32. ;
        informat Product_reviews_tfal best32. ;
        informat nonbbox3pprice_tfal best32. ;
        informat buyboxprice_csnart best32. ;
        informat product_star_csnart best32. ;
        informat Sales_Rank_Own_Categ_csnart best32. ;
        informat Sales_Rank_Sub_categ_csnart best32. ;
        informat Answered_Questionscsnart best32. ;
        informat Product_reviews_csnart best32. ;
        informat nonbbox3pprice_csnart best32. ;
        informat num_pricechange1prestoused3p best32. ;
        informat num_pricechange1prestousedamzn best32. ;
        informat num_pricechange1prestoamzn best32. ;
        informat num_pricechange1prestoclust1 best32. ;
        informat num_pricechange1prestoclust2 best32. ;
        informat num_pricechange1prestoclust3 best32. ;
        informat num_pricechange1prestoclust4 best32. ;
        informat num_pricechange1prestoclust5 best32. ;
        informat num_pricechange1securaused3p best32. ;
        informat num_pricechange1securausedamzn best32. ;
        informat num_pricechange1securaamzn best32. ;
        informat num_pricechange1securaclust1 best32. ;
        informat num_pricechange1securaclust2 best32. ;
        informat num_pricechange1securaclust3 best32. ;
        informat num_pricechange1securaclust4 best32. ;
        informat num_pricechange1securaclust5 best32. ;
        informat num_pricechange1EPused3p best32. ;
        informat num_pricechange1EPusedamzn best32. ;
        informat num_pricechange1EPamzn best32. ;
        informat num_pricechange1EPclust1 best32. ;
        informat num_pricechange1EPclust2 best32. ;
        informat num_pricechange1EPclust3 best32. ;
       informat num_pricechange1EPclust4 best32. ;
       informat num_pricechange1EPclust5 best32. ;
       informat num_pricechange1Hbeachused3p best32. ;
       informat num_pricechange1Hbeachusedamzn best32. ;
       informat num_pricechange1Hbeachamzn best32. ;
       informat num_pricechange1Hbeachclust1 best32. ;
       informat num_pricechange1Hbeachclust2 best32. ;
       informat num_pricechange1Hbeachclust3 best32. ;
       informat num_pricechange1Hbeachclust4 best32. ;
       informat num_pricechange1Hbeachclust5 best32. ;
       informat num_pricechange1tfalused3p best32. ;
       informat num_pricechange1tfalusedamzn best32. ;
       informat num_pricechange1tfalamzn best32. ;
       informat num_pricechange1tfalclust1 best32. ;
       informat num_pricechange1tfalclust2 best32. ;
       informat num_pricechange1tfalclust3 best32. ;
       informat num_pricechange1tfalclust4 best32. ;
       informat num_pricechange1tfalclust5 best32. ;
       informat num_pricechange1csnartused3p best32. ;
       informat num_pricechange1csnartusedamzn best32. ;
       informat num_pricechange1csnartamzn best32. ;
       informat num_pricechange1csnartclust1 best32. ;
       informat num_pricechange1csnartclust2 best32. ;
       informat num_pricechange1csnartclust3 best32. ;
       informat num_pricechange1csnartclust4 best32. ;
       informat num_pricechange1csnartclust5 best32. ;
       informat season best32. ;
       informat mean_pricechange_HD best32. ;
       informat maxpricechange_HD best32. ;
       informat mean_pricechange_wm best32. ;
       informat maxpricechange_wm best32. ;
       informat mean_pricechange_sears best32. ;
       informat maxpricechange_sears best32. ;
       informat ext_site best32. ;
       informat day_week best32. ;
       informat sunday best32. ;
       informat monday best32. ;
       informat tuesday best32. ;
       informat wednesday best32. ;
       informat thursday best32. ;
       informat friday best32. ;
       informat saturday best32. ;
       informat weekend best32. ;
       informat maxpricechange_HDlag1 best32. ;
       informat maxpricechange_searslag1 best32. ;
       informat maxpricechange_wmlag1 best32. ;
       informat maxpricechange_HDlag2 best32. ;
       informat maxpricechange_searslag2 best32. ;
       informat maxpricechange_wmlag2 best32. ;
       informat maxpricechange_HDlag3 best32. ;
       informat maxpricechange_searslag3 best32. ;
       informat maxpricechange_wmlag3 best32. ;
       informat top_salesrank best32. ;
       informat bottom_salesrank best32. ;
       informat ep_topbrandlag1 best32. ;
       informat presto_topbrandlag1 best32. ;
       informat hbeach_topbrandlag1 best32. ;
       informat csnart_topbrandlag1 best32. ;
       informat secura_topbrandlag1 best32. ;
       informat tfal_topbrandlag1 best32. ;
       informat ep_bottombrandlag1 best32. ;
       informat presto_bottombrandlag1 best32. ;
       informat hbeach_bottombrandlag1 best32. ;
       informat csnart_bottombrandlag1 best32. ;
       informat secura_bottombrandlag1 best32. ;
       informat tfal_bottombrandlag1 best32. ;
       informat incr5per_amzn_csnart best32. ;
       informat decr5per_amzn_csnart best32. ;
       informat incr10per_amzn_csnart best32. ;
       informat decr10per_amzn_csnart best32. ;
       informat incr20per_amzn_csnart best32. ;
       informat decr20per_amzn_csnart best32. ;
       informat incr5per_clust1_csnart best32. ;
       informat incr5per_clust3_csnart best32. ;
       informat incr5per_clust5_tfal best32. ;
       informat decr5per_clust1_csnart best32. ;
       informat decr5per_clust3_csnart best32. ;
       informat decr5per_clust5_tfal best32. ;
       informat incr10per_clust1_csnart best32. ;
       informat incr10per_clust3_csnart best32. ;
       informat incr10per_clust5_tfal best32. ;
       informat decr10per_clust1_csnart best32. ;
       informat decr10per_clust3_csnart best32. ;
       informat decr10per_clust5_tfal best32. ;
       informat incr20per_clust1_csnart best32. ;
       informat incr20per_clust3_csnart best32. ;
       informat incr20per_clust5_tfal best32. ;
       informat decr20per_clust1_csnart best32. ;
       informat decr20per_clust3_csnart best32. ;
       informat decr20per_clust5_tfal best32. ;
       informat incr5per_amzn_hbeach best32. ;
       informat decr5per_amzn_hbeach best32. ;
       informat incr10per_amzn_hbeach best32. ;
       informat decr10per_amzn_hbeach best32. ;
       informat incr20per_amzn_hbeach best32. ;
       informat decr20per_amzn_hbeach best32. ;
       informat incr5per_amzn_presto best32. ;
       informat decr5per_amzn_presto best32. ;
       informat incr10per_amzn_presto best32. ;
       informat decr10per_amzn_presto best32. ;
       informat incr20per_amzn_presto best32. ;
       informat decr20per_amzn_presto best32. ;
       informat incr5per_amzn_tfal best32. ;
       informat decr5per_amzn_tfal best32. ;
       informat incr10per_amzn_tfal best32. ;
       informat decr10per_amzn_tfal best32. ;
       informat incr20per_amzn_tfal best32. ;
       informat decr20per_amzn_tfal best32. ;
       informat incr5per_3p_tfal best32. ;
       informat decr5per_3p_tfal best32. ;
       informat incr10per_3p_tfal best32. ;
       informat decr10per_3p_tfal best32. ;
       informat incr20per_3p_tfal best32. ;
       informat decr20per_3p_tfal best32. ;
       informat incr5per_3p_sec best32. ;
       informat decr5per_3p_sec best32. ;
       informat incr10per_3p_sec best32. ;
       informat decr10per_3p_sec best32. ;
       informat incr20per_3p_sec best32. ;
       informat decr20per_3p_sec best32. ;
       format TIME best12. ;
       format Y_amzn_csnart_lag1 best12. ;
       format Y_amzn_csnart_lag2 best12. ;
       format Y_amzn_csnart_lag3 best12. ;
       format Y_amzn_hbeach_lag1 best12. ;
       format Y_amzn_hbeach_lag2 best12. ;
       format Y_amzn_hbeach_lag3 best12. ;
       format Y_amzn_presto_lag1 best12. ;
       format Y_amzn_presto_lag2 best12. ;
       format Y_amzn_presto_lag3 best12. ;
       format Y_amzn_tfal_lag1 best12. ;
       format Y_amzn_tfal_lag2 best12. ;
       format Y_amzn_tfal_lag3 best12. ;
       format Y_clust1_csnart_lag1 best12. ;
       format Y_clust1_csnart_lag2 best12. ;
       format Y_clust1_csnart_lag3 best12. ;
       format Y_clust2_tfal_lag1 best12. ;
       format Y_clust2_tfal_lag2 best12. ;
       format Y_clust2_tfal_lag3 best12. ;
       format Y_clust3_csnart_lag1 best12. ;
       format Y_clust3_csnart_lag2 best12. ;
       format Y_clust3_csnart_lag3 best12. ;
       format Y_clust4_secura_lag1 best12. ;
       format Y_clust4_secura_lag2 best12. ;
       format Y_clust4_secura_lag3 best12. ;
       format Y_clust5_tfal_lag1 best12. ;
       format Y_clust5_tfal_lag2 best12. ;
       format Y_clust5_tfal_lag3 best12. ;
       format Answered_QuestionsEP_lag1 best12. ;
       format Answered_QuestionsHbeach_lag1 best12. ;
       format Answered_Questionscsnart_lag1 best12. ;
       format Answered_Questionssecura_lag1 best12. ;
       format Answered_Questionstfal_lag1 best12. ;
       format FBA_used3p_lag1 best12. ;
       format Freeship_amzn_lag1 best12. ;
       format Freeship_used3p_lag1 best12. ;
       format Freeship_usedamzn_lag1 best12. ;
       format nonbbox3pprice_EP_lag best12. ;
       format nonbbox3pprice_Hbeach_lag best12. ;
       format nonbbox3pprice_csnart_lag best12. ;
       format nonbbox3pprice_secura_lag best12. ;
       format nonbbox3pprice_tfal_lag best12. ;
       format NUM_SELLERSamzn_lag1 best12. ;
       format NUM_SELLERSclust1_lag1 best12. ;
       format NUM_SELLERSclust2_lag1 best12. ;
       format NUM_SELLERSclust3_lag1 best12. ;
       format NUM_SELLERSclust4_lag1 best12. ;
       format NUM_SELLERSclust5_lag1 best12. ;
       format NUM_SELLERSused3p_lag1 best12. ;
       format NUM_SELLERSusedamzn_lag1 best12. ;
       format NUM_SKUSamzn_lag1 best12. ;
       format NUM_SKUSclust1_lag1 best12. ;
       format NUM_SKUSclust2_lag1 best12. ;
       format NUM_SKUSclust3_lag1 best12. ;
       format NUM_SKUSclust4_lag1 best12. ;
       format NUM_SKUSclust5_lag1 best12. ;
       format NUM_SKUSused3p_lag1 best12. ;
       format NUM_SKUSusedamzn_lag1 best12. ;
       format NUM_prestoamzn_lag1 best12. ;
       format NUM_prestoclust1_lag1 best12. ;
       format NUM_prestoclust2_lag1 best12. ;
       format NUM_prestoclust3_lag1 best12. ;
       format NUM_prestoclust4_lag1 best12. ;
       format NUM_prestoclust5_lag1 best12. ;
       format NUM_prestoused3p_lag1 best12. ;
       format NUM_prestousedamzn_lag1 best12. ;
       format Product_reviews_EP_lag1 best12. ;
       format Product_reviews_Hbeach_lag1 best12. ;
       format Product_reviews_csnart_lag1 best12. ;
       format Product_reviews_secura_lag1 best12. ;
       format Product_reviews_tfal_lag1 best12. ;
       format salerank_EP_lag1 best12. ;
       format salerank_Hbeach_lag1 best12. ;
       format salerank_csnart_lag1 best12. ;
       format salerank_secura_lag1 best12. ;
       format salerank_tfal_lag1 best12. ;
       format saleranksubcat_EP_lag1 best12. ;
       format saleranksubcat_Hbeach_lag1 best12. ;
       format saleranksubcat_csnart_lag1 best12. ;
       format saleranksubcat_secura_lag1 best12. ;
       format saleranksubcat_tfal_lag1 best12. ;
       format buyboxprice_EP_lag1 best12. ;
       format buyboxprice_Hbeach_lag1 best12. ;
       format buyboxprice_csnart_lag1 best12. ;
       format buyboxprice_secura_lag1 best12. ;
       format buyboxprice_tfal_lag1 best12. ;
       format cumsalefreq_amzn_lag1 best12. ;
       format max_Product_reviews_presto_lag1 best12. ;
       format max_ans_questions_presto_lag1 best12. ;
       format max_buyboxprice_presto_lag1 best12. ;
       format max_cumsalefreq_clust1_lag1 best12. ;
       format max_cumsalefreq_clust2_lag1 best12. ;
       format max_cumsalefreq_clust3_lag1 best12. ;
       format max_cumsalefreq_clust4_lag1 best12. ;
       format max_cumsalefreq_clust5_lag1 best12. ;
       format maxnumsellerrate_clust1_lag1 best12. ;
       format maxnumsellerate_clust2_lag1 best12. ;
       format maxnumsellerate_clust3_lag1 best12. ;
       format maxnumsellerate_clust4_lag1 best12. ;
       format maxnumsellerate_clust5_lag1 best12. ;
       format maxpercsellerate_clust1_lag1 best12. ;
       format maxpercsellerate_clust2_lag1 best12. ;
       format maxpercsellerate_clust3_lag1 best12. ;
       format maxpercsellerate_clust4_lag1 best12. ;
       format maxpercsellerate_clust5_lag1 best12. ;
       format maxprodstar_presto_lag1 best12. ;
       format maxsalerank_presto_lag1 best12. ;
       format maxsaleranksubcat_presto_lag1 best12. ;
       format maxsellerstar_clust1_lag1 best12. ;
       format maxsellerstar_clust2_lag1 best12. ;
       format maxsellerstar_clust3_lag1 best12. ;
       format maxsellerstar_clust4_lag1 best12. ;
       format maxsellerstar_clust5_lag1 best12. ;
       format max_uniq_ASIN_clust1_lag1 best12. ;
       format max_uniq_ASIN_clust2_lag1 best12. ;
       format max_uniq_ASIN_clust3_lag1 best12. ;
       format max_uniq_ASIN_clust4_lag1 best12. ;
       format max_uniq_ASIN_clust5_lag1 best12. ;
       format mean_Product_reviews_presto_lag1 best12. ;
       format mean_ans_questions_presto_lag1 best12. ;
       format mean_buyboxprice_presto_lag1 best12. ;
       format mean_nonbbox3p_presto_lag best12. ;
       format mean_cumsalefreq_clust1_lag1 best12. ;
       format mean_cumsalefreq_clust2_lag1 best12. ;
       format mean_cumsalefreq_clust3_lag1 best12. ;
       format mean_cumsalefreq_clust4_lag1 best12. ;
       format mean_cumsalefreq_clust5_lag1 best12. ;
       format meannumsellerate_clust1_lag1 best12. ;
       format meannumsellerate_clust2_lag1 best12. ;
       format meannumsellerate_clust3_lag1 best12. ;
       format meannumsellerate_clust4_lag1 best12. ;
       format meannumsellerate_clust5_lag1 best12. ;
       format meanpercsellerate_clust1_lag1 best12. ;
       format meanpercsellerate_clust2_lag1 best12. ;
       format meanpercsellerate_clust3_lag1 best12. ;
       format meanpercsellerate_clust4_lag1 best12. ;
       format meanpercsellerate_clust5_lag1 best12. ;
       format meanprodstar_presto_lag1 best12. ;
       format meansalerank_presto_lag1 best12. ;
       format meansaleranksubcat_presto_lag1 best12. ;
       format meansellerstar_clust1_lag1 best12. ;
       format meansellerstar_clust2_lag1 best12. ;
       format meansellerstar_clust3_lag1 best12. ;
       format meansellerstar_clust4_lag1 best12. ;
       format meansellerstar_clust5_lag1 best12. ;
       format mean_uniq_ASIN_clust1_lag1 best12. ;
       format mean_uniq_ASIN_clust2_lag1 best12. ;
       format mean_uniq_ASIN_clust3_lag1 best12. ;
       format mean_uniq_ASIN_clust4_lag1 best12. ;
       format mean_uniq_ASIN_clust5_lag1 best12. ;
       format min_Product_reviews_presto_lag1 best12. ;
       format min_ans_questions_presto_lag1 best12. ;
       format min_buyboxprice_presto_lag1 best12. ;
       format min_cumsalefreq_clust1_lag1 best12. ;
       format min_cumsalefreq_clust2_lag1 best12. ;
       format min_cumsalefreq_clust3_lag1 best12. ;
       format min_cumsalefreq_clust4_lag1 best12. ;
       format min_cumsalefreq_clust5_lag1 best12. ;
       format minnumsellerate_clust1_lag1 best12. ;
       format minnumsellerate_clust2_lag1 best12. ;
       format minnumsellerate_clust3_lag1 best12. ;
       format minnumsellerate_clust4_lag1 best12. ;
       format minnumsellerate_clust5_lag1 best12. ;
       format minpercsellerate_clust1_lag1 best12. ;
       format minpercsellerate_clust2_lag1 best12. ;
       format minpercsellerate_clust3_lag1 best12. ;
       format minpercsellerate_clust4_lag1 best12. ;
       format minpercsellerate_clust5_lag1 best12. ;
       format minproductstar_presto_lag1 best12. ;
       format minsalerank_presto_lag1 best12. ;
       format minsaleranksubcat_presto_lag1 best12. ;
       format minsellerstar_clust1_lag1 best12. ;
       format minsellerstar_clust2_lag1 best12. ;
       format minsellerstar_clust3_lag1 best12. ;
       format minsellerstar_clust4_lag1 best12. ;
       format minsellerstar_clust5_lag1 best12. ;
       format min_uniq_ASIN_clust1_lag1 best12. ;
       format min_uniq_ASIN_clust2_lag1 best12. ;
       format min_uniq_ASIN_clust3_lag1 best12. ;
       format min_uniq_ASIN_clust4_lag1 best12. ;
       format min_uniq_ASIN_clust5_lag1 best12. ;
       format num_EPamzn_lag1 best12. ;
       format num_EPclust1_lag1 best12. ;
       format num_EPclust2_lag1 best12. ;
       format num_EPclust3_lag1 best12. ;
       format num_EPclust4_lag1 best12. ;
       format num_EPclust5_lag1 best12. ;
       format num_EPused3p_lag1 best12. ;
       format num_EPusedamzn_lag1 best12. ;
       format num_FBA_clust1_lag1 best12. ;
       format num_FBA_clust2_lag1 best12. ;
       format num_FBA_clust3_lag1 best12. ;
       format num_FBA_clust4_lag1 best12. ;
       format num_FBA_clust5_lag1 best12. ;
       format num_Freeship_clust1_lag1 best12. ;
       format num_Freeship_clust2_lag1 best12. ;
       format num_Freeship_clust3_lag1 best12. ;
       format num_Freeship_clust4_lag1 best12. ;
       format num_Freeship_clust5_lag1 best12. ;
       format num_HBeachamzn_lag1 best12. ;
       format num_HBeachclust1_lag1 best12. ;
       format num_HBeachclust2_lag1 best12. ;
       format num_HBeachclust3_lag1 best12. ;
       format num_HBeachclust4_lag1 best12. ;
       format num_HBeachclust5_lag1 best12. ;
       format num_HBeachused3p_lag1 best12. ;
       format num_HBeachusedamzn_lag1 best12. ;
       format num_csnartamzn_lag1 best12. ;
       format num_csnartclust1_lag1 best12. ;
       format num_csnartclust2_lag1 best12. ;
       format num_csnartclust3_lag1 best12. ;
       format num_csnartclust4_lag1 best12. ;
       format num_csnartclust5_lag1 best12. ;
       format num_csnartused3p_lag1 best12. ;
       format num_csnartusedamzn_lag1 best12. ;
       format pricechangeEPamzn_lag1 best12. ;
       format pricechangeEPclust1_lag1 best12. ;
       format pricechangeEPclust2_lag1 best12. ;
       format pricechangeEPclust3_lag1 best12. ;
       format pricechangeEPclust4_lag1 best12. ;
       format pricechangeEPclust5_lag1 best12. ;
       format pricechangeEPused3p_lag1 best12. ;
       format pricechangeEPusedamzn_lag1 best12. ;
       format pricechangeHbeachamzn_lag1 best12. ;
       format pricechangeHbeachclust1_lag1 best12. ;
       format pricechangeHbeachclust2_lag1 best12. ;
       format pricechangeHbeachclust3_lag1 best12. ;
       format pricechangeHbeachclust4_lag1 best12. ;
       format pricechangeHbeachclust5_lag1 best12. ;
       format pricechangeHbeachused3p_lag1 best12. ;
       format pricechangeHbeachusedamzn_lag1 best12. ;
       format pricechangecsnartamzn_lag1 best12. ;
       format pricechangecsnartclust1_lag1 best12. ;
       format pricechangecsnartclust2_lag1 best12. ;
       format pricechangecsnartclust3_lag1 best12. ;
       format pricechangecsnartclust4_lag1 best12. ;
       format pricechangecsnartclust5_lag1 best12. ;
       format pricechangecsnartused3p_lag1 best12. ;
       format pricechangecsnartusedamzn_lag1 best12. ;
       format pricechangeprestoamzn_lag1 best12. ;
       format pricechangeprestoclust1_lag1 best12. ;
       format pricechangeprestoclust2_lag1 best12. ;
       format pricechangeprestoclust3_lag1 best12. ;
       format pricechangeprestoclust4_lag1 best12. ;
       format pricechangeprestoclust5_lag1 best12. ;
       format pricechangeprestoused3p_lag1 best12. ;
       format pricechangeprestousedamzn_lag1 best12. ;
       format pricechangesecuraamzn_lag1 best12. ;
       format pricechangesecuraclust1_lag1 best12. ;
       format pricechangesecuraclust2_lag1 best12. ;
       format pricechangesecuraclust3_lag1 best12. ;
       format pricechangesecuraclust4_lag1 best12. ;
       format pricechangesecuraclust5_lag1 best12. ;
       format pricechangesecuraused3p_lag1 best12. ;
       format pricechangesecurausedamzn_lag1 best12. ;
       format pricechangetfalamzn_lag1 best12. ;
       format pricechangetfalclust1_lag1 best12. ;
       format pricechangetfalclust2_lag1 best12. ;
       format pricechangetfalclust3_lag1 best12. ;
       format pricechangetfalclust4_lag1 best12. ;
       format pricechangetfalclust5_lag1 best12. ;
       format pricechangetfalused3p_lag1 best12. ;
       format pricechangetfalusedamzn_lag1 best12. ;
       format num_securaamzn_lag1 best12. ;
       format num_securaclust1_lag1 best12. ;
       format num_securaclust2_lag1 best12. ;
       format num_securaclust3_lag1 best12. ;
       format num_securaclust4_lag1 best12. ;
       format num_securaclust5_lag1 best12. ;
       format num_securaused3p_lag1 best12. ;
       format num_securausedamzn_lag1 best12. ;
       format num_tfalamzn_lag1 best12. ;
       format num_tfalclust1_lag1 best12. ;
       format num_tfalclust2_lag1 best12. ;
       format num_tfalclust3_lag1 best12. ;
       format num_tfalclust4_lag1 best12. ;
       format num_tfalclust5_lag1 best12. ;
       format num_tfalused3p_lag1 best12. ;
       format num_tfalusedamzn_lag1 best12. ;
       format priceAmzn_Hbeach_lag best12. ;
       format priceAmzn_csnart_lag best12. ;
       format priceAmzn_presto_lag best12. ;
       format priceAmzn_tfal_lag best12. ;
       format priceclust1_csnart_lag best12. ;
       format priceclust2_tfal_lag best12. ;
       format priceclust3_csnart_lag best12. ;
       format priceclust4_secura_lag best12. ;
       format priceclust5_tfal_lag best12. ;
       format pricedifflowst_AmznHbeach_lag best12. ;
       format pricedifflowst_Amzncsnart_lag best12. ;
       format pricedifflowst_Amznpresto_lag best12. ;
       format pricedifflowst_Amzntfal_lag best12. ;
       format pricedifflowst_clust1csnart_lag best12.  ;
       format pricedifflowst_clust2tfal_lag best12.  ;
       format pricedifflowst_clust3csn_lag best12. ;
       format pricedifflowst_clust4sec_lag best12. ;
       format pricedifflowst_clust5tfal_lag best12.  ;
       format productstar_EP_lag1 best12. ;
       format productstar_Hbeach_lag1 best12. ;
       format productstar_csnart_lag1 best12. ;
       format productstar_secura_lag1 best12. ;
       format productstar_tfal_lag1 best12. ;
       format time1 mmddyy10. ;
       format priceAmzn_tfal best12. ;
       format pricediff_lowst_Amzn_tfal best12. ;
       format Y_amzn_tfal best12. ;
       format priceAmzn_Hbeach best12. ;
       format pricediff_lowst_Amzn_Hbeach best12. ;
       format Y_amzn_hbeach best12. ;
       format priceAmzn_presto best12. ;
       format pricediff_lowst_Amzn_presto best12. ;
       format Y_amzn_presto best12. ;
       format priceAmzn_csnart best12. ;
       format pricediff_lowst_Amzn_csnart best12. ;
       format Y_amzn_csnart best12. ;
       format priceclust1_csnart best12.  ;
       format pricediff_lowst_clust1_csnart best12.  ;
       format Y_clust1_csnart best12. ;
       format priceclust2_tfal best12.  ;
       format pricediff_lowst_clust2_tfal best12.  ;
       format Y_clust2_tfal best12. ;
       format priceclust3_csnart best12. ;
       format pricediff_lowst_clust3_csnart best12. ;
       format Y_clust3_csnart best12. ;
       format priceclust4_secura best12. ;
       format pricediff_lowst_clust4_secura best12. ;
       format Y_clust4_secura best12. ;
       format priceclust5_tfal best12.  ;
       format pricediff_lowst_clust5_tfal best12.  ;
       format Y_clust5_tfal best12. ;
       format Freeship_amzn best12. ;
       format cumsalefreq_amzn best12. ;
       format Freeship_usedamzn best12. ;
       format FBA_used3p best12. ;
       format Freeship_used3p best12. ;
       format num_FBA_clust1 best12. ;
       format num_Freeship_clust1 best12. ;
       format max_perct_sellerrating_clust1 best12. ;
       format mean_perct_sellerrating_clust1 best12. ;
       format min_perct_sellerrating_clust1 best12. ;
       format max_num_seller_rating_clust1 best12. ;
       format mean_num_seller_rating_clust1 best12. ;
       format min_num_seller_rating_clust1 best12. ;
       format max_seller_star_rating_clust1 best12. ;
       format mean_seller_star_rating_clust1 best12. ;
       format min_seller_star_rating_clust1 best12. ;
       format max_uniq_ASIN_clust1 best12. ;
       format mean_uniq_ASIN_clust1 best12. ;
       format min_uniq_ASIN_clust1 best12. ;
       format max_cumsalefreq_clust1 best12. ;
       format mean_cumsalefreq_clust1 best12. ;
       format min_cumsalefreq_clust1 best12. ;
       format num_FBA_clust2 best12. ;
       format num_Freeship_clust2 best12. ;
       format max_perct_sellerrating_clust2 best12. ;
       format mean_perct_sellerrating_clust2 best12. ;
       format min_perct_sellerrating_clust2 best12. ;
       format max_num_seller_rating_clust2 best12. ;
       format mean_num_seller_rating_clust2 best12. ;
       format min_num_seller_rating_clust2 best12. ;
       format max_seller_star_rating_clust2 best12. ;
       format mean_seller_star_rating_clust2 best12. ;
       format min_seller_star_rating_clust2 best12. ;
       format max_uniq_ASIN_clust2 best12. ;
       format mean_uniq_ASIN_clust2 best12. ;
       format min_uniq_ASIN_clust2 best12. ;
       format max_cumsalefreq_clust2 best12. ;
       format mean_cumsalefreq_clust2 best12. ;
       format min_cumsalefreq_clust2 best12. ;
       format num_FBA_clust3 best12. ;
       format num_Freeship_clust3 best12. ;
       format max_perct_sellerrating_clust3 best12. ;
       format mean_perct_sellerrating_clust3 best12. ;
       format min_perct_sellerrating_clust3 best12. ;
       format max_num_seller_rating_clust3 best12. ;
       format mean_num_seller_rating_clust3 best12. ;
       format min_num_seller_rating_clust3 best12. ;
       format max_seller_star_rating_clust3 best12. ;
       format mean_seller_star_rating_clust3 best12. ;
       format min_seller_star_rating_clust3 best12. ;
       format max_uniq_ASIN_clust3 best12. ;
       format mean_uniq_ASIN_clust3 best12. ;
       format min_uniq_ASIN_clust3 best12. ;
       format max_cumsalefreq_clust3 best12. ;
       format mean_cumsalefreq_clust3 best12. ;
       format min_cumsalefreq_clust3 best12. ;
       format num_FBA_clust4 best12. ;
       format num_Freeship_clust4 best12. ;
       format max_perct_sellerrating_clust4 best12. ;
       format mean_perct_sellerrating_clust4 best12. ;
       format min_perct_sellerrating_clust4 best12. ;
       format max_num_seller_rating_clust4 best12. ;
       format mean_num_seller_rating_clust4 best12. ;
       format min_num_seller_rating_clust4 best12. ;
       format max_seller_star_rating_clust4 best12. ;
       format mean_seller_star_rating_clust4 best12. ;
       format min_seller_star_rating_clust4 best12. ;
       format max_uniq_ASIN_clust4 best12. ;
       format mean_uniq_ASIN_clust4 best12. ;
       format min_uniq_ASIN_clust4 best12. ;
       format max_cumsalefreq_clust4 best12. ;
       format mean_cumsalefreq_clust4 best12. ;
       format min_cumsalefreq_clust4 best12. ;
       format num_FBA_clust5 best12. ;
       format num_Freeship_clust5 best12. ;
       format max_perct_sellerrating_clust5 best12. ;
       format mean_perct_sellerrating_clust5 best12. ;
       format min_perct_sellerrating_clust5 best12. ;
       format max_num_seller_rating_clust5 best12. ;
       format mean_num_seller_rating_clust5 best12. ;
       format min_num_seller_rating_clust5 best12. ;
       format max_seller_star_rating_clust5 best12. ;
       format mean_seller_star_rating_clust5 best12. ;
       format min_seller_star_rating_clust5 best12. ;
       format max_uniq_ASIN_clust5 best12. ;
       format mean_uniq_ASIN_clust5 best12. ;
       format min_uniq_ASIN_clust5 best12. ;
       format max_cumsalefreq_clust5 best12. ;
       format mean_cumsalefreq_clust5 best12. ;
       format min_cumsalefreq_clust5 best12. ;
       format max_ans_questions_presto best12. ;
       format mean_ans_questions_presto best12. ;
       format min_ans_questions_presto best12. ;
       format max_buyboxprice_presto best12. ;
       format mean_buyboxprice_presto best12. ;
       format min_buyboxprice_presto best12. ;
       format max_nonbbox3pprice_presto best12. ;
       format mean_nonbbox3pprice_presto best12. ;
       format min_nonbbox3pprice_presto best12. ;
       format max_product_star_rate_presto best12. ;
       format mean_product_star_rate_presto best12. ;
       format min_product_star_rate_presto best12. ;
       format max_Product_reviews_presto best12. ;
       format mean_Product_reviews_presto best12. ;
       format min_Product_reviews_presto best12. ;
       format max_salesrank_categ_presto best12. ;
       format mean_salesrank_categ_presto best12. ;
       format min_salesrank_categ_presto best12. ;
       format max_salesrank_subcateg_presto best12. ;
       format mean_salesrank_subcateg_presto best12. ;
       format min_salesrank_subcateg_presto best12. ;
       format NUM_SELLERSused3p best12. ;
       format NUM_SKUSused3p best12. ;
       format NUM_prestoused3p best12. ;
       format num_securaused3p best12. ;
       format num_EPused3p best12. ;
       format num_HBeachused3p best12. ;
       format num_tfalused3p best12. ;
       format num_csnartused3p best12. ;
       format NUM_SELLERSusedamzn best12. ;
       format NUM_SKUSusedamzn best12. ;
       format NUM_prestousedamzn best12. ;
       format num_securausedamzn best12. ;
       format num_EPusedamzn best12. ;
       format num_HBeachusedamzn best12. ;
       format num_tfalusedamzn best12. ;
       format num_csnartusedamzn best12. ;
       format NUM_SELLERSamzn best12. ;
       format NUM_SKUSamzn best12. ;
       format NUM_prestoamzn best12. ;
       format num_securaamzn best12. ;
       format num_EPamzn best12. ;
       format num_HBeachamzn best12. ;
       format num_tfalamzn best12. ;
       format num_csnartamzn best12. ;
       format NUM_SELLERSclust1 best12. ;
       format NUM_SKUSclust1 best12. ;
       format NUM_prestoclust1 best12. ;
       format num_securaclust1 best12. ;
       format num_EPclust1 best12. ;
       format num_HBeachclust1 best12. ;
       format num_tfalclust1 best12. ;
       format num_csnartclust1 best12. ;
       format NUM_SELLERSclust2 best12. ;
       format NUM_SKUSclust2 best12. ;
       format NUM_prestoclust2 best12. ;
       format num_securaclust2 best12. ;
       format num_EPclust2 best12. ;
       format num_HBeachclust2 best12. ;
       format num_tfalclust2 best12. ;
       format num_csnartclust2 best12. ;
       format NUM_SELLERSclust3 best12. ;
       format NUM_SKUSclust3 best12. ;
       format NUM_prestoclust3 best12. ;
       format num_securaclust3 best12. ;
       format num_EPclust3 best12. ;
       format num_HBeachclust3 best12. ;
       format num_tfalclust3 best12. ;
       format num_csnartclust3 best12. ;
       format NUM_SELLERSclust4 best12. ;
       format NUM_SKUSclust4 best12. ;
       format NUM_prestoclust4 best12. ;
       format num_securaclust4 best12. ;
       format num_EPclust4 best12. ;
       format num_HBeachclust4 best12. ;
       format num_tfalclust4 best12. ;
       format num_csnartclust4 best12. ;
       format NUM_SELLERSclust5 best12. ;
       format NUM_SKUSclust5 best12. ;
       format NUM_prestoclust5 best12. ;
       format num_securaclust5 best12. ;
       format num_EPclust5 best12. ;
       format num_HBeachclust5 best12. ;
       format num_tfalclust5 best12. ;
       format num_csnartclust5 best12. ;
       format buyboxprice_secura best12. ;
       format product_star_secura best12. ;
       format Sales_Rank_Own_Categ_secura best12. ;
       format Sales_Rank_Sub_categ_secura best12. ;
       format Answered_Questionssecura best12. ;
       format Product_reviews_secura best12. ;
       format nonbbox3pprice_secura best12. ;
       format buyboxprice_EP best12. ;
       format product_star_EP best12. ;
       format Sales_Rank_Own_Categ_EP best12. ;
       format Sales_Rank_Sub_categ_EP best12. ;
       format Answered_QuestionsEP best12. ;
       format Product_reviews_EP best12. ;
       format nonbbox3pprice_EP best12. ;
       format buyboxprice_Hbeach best12. ;
       format product_star_Hbeach best12. ;
       format Sales_Rank_Own_Categ_Hbeach best12. ;
       format Sales_Rank_Sub_categ_Hbeach best12. ;
       format Answered_QuestionsHbeach best12. ;
       format Product_reviews_Hbeach best12. ;
       format nonbbox3pprice_Hbeach best12. ;
       format buyboxprice_tfal best12. ;
       format product_star_tfal best12. ;
       format Sales_Rank_Own_Categ_tfal best12. ;
       format Sales_Rank_Sub_categ_tfal best12. ;
       format Answered_Questionstfal best12. ;
       format Product_reviews_tfal best12. ;
       format nonbbox3pprice_tfal best12. ;
       format buyboxprice_csnart best12. ;
       format product_star_csnart best12. ;
       format Sales_Rank_Own_Categ_csnart best12. ;
       format Sales_Rank_Sub_categ_csnart best12. ;
       format Answered_Questionscsnart best12. ;
       format Product_reviews_csnart best12. ;
       format nonbbox3pprice_csnart best12. ;
       format num_pricechange1prestoused3p best12. ;
       format num_pricechange1prestousedamzn best12. ;
       format num_pricechange1prestoamzn best12. ;
       format num_pricechange1prestoclust1 best12. ;
       format num_pricechange1prestoclust2 best12. ;
       format num_pricechange1prestoclust3 best12. ;
       format num_pricechange1prestoclust4 best12. ;
       format num_pricechange1prestoclust5 best12. ;
       format num_pricechange1securaused3p best12. ;
       format num_pricechange1securausedamzn best12. ;
       format num_pricechange1securaamzn best12. ;
       format num_pricechange1securaclust1 best12. ;
       format num_pricechange1securaclust2 best12. ;
       format num_pricechange1securaclust3 best12. ;
       format num_pricechange1securaclust4 best12. ;
       format num_pricechange1securaclust5 best12. ;
       format num_pricechange1EPused3p best12. ;
       format num_pricechange1EPusedamzn best12. ;
       format num_pricechange1EPamzn best12. ;
       format num_pricechange1EPclust1 best12. ;
       format num_pricechange1EPclust2 best12. ;
       format num_pricechange1EPclust3 best12. ;
       format num_pricechange1EPclust4 best12. ;
       format num_pricechange1EPclust5 best12. ;
       format num_pricechange1Hbeachused3p best12. ;
       format num_pricechange1Hbeachusedamzn best12. ;
       format num_pricechange1Hbeachamzn best12. ;
       format num_pricechange1Hbeachclust1 best12. ;
       format num_pricechange1Hbeachclust2 best12. ;
       format num_pricechange1Hbeachclust3 best12. ;
       format num_pricechange1Hbeachclust4 best12. ;
       format num_pricechange1Hbeachclust5 best12. ;
       format num_pricechange1tfalused3p best12. ;
       format num_pricechange1tfalusedamzn best12. ;
       format num_pricechange1tfalamzn best12. ;
       format num_pricechange1tfalclust1 best12. ;
       format num_pricechange1tfalclust2 best12. ;
       format num_pricechange1tfalclust3 best12. ;
       format num_pricechange1tfalclust4 best12. ;
       format num_pricechange1tfalclust5 best12. ;
       format num_pricechange1csnartused3p best12. ;
       format num_pricechange1csnartusedamzn best12. ;
       format num_pricechange1csnartamzn best12. ;
       format num_pricechange1csnartclust1 best12. ;
       format num_pricechange1csnartclust2 best12. ;
       format num_pricechange1csnartclust3 best12. ;
       format num_pricechange1csnartclust4 best12. ;
       format num_pricechange1csnartclust5 best12. ;
       format season best12. ;
       format mean_pricechange_HD best12. ;
       format maxpricechange_HD best12. ;
       format mean_pricechange_wm best12. ;
       format maxpricechange_wm best12. ;
       format mean_pricechange_sears best12. ;
       format maxpricechange_sears best12. ;
       format ext_site best12. ;
       format day_week best12. ;
       format sunday best12. ;
       format monday best12. ;
       format tuesday best12. ;
       format wednesday best12. ;
       format thursday best12. ;
       format friday best12. ;
       format saturday best12. ;
       format weekend best12. ;
       format maxpricechange_HDlag1 best12. ;
       format maxpricechange_searslag1 best12. ;
       format maxpricechange_wmlag1 best12. ;
       format maxpricechange_HDlag2 best12. ;
       format maxpricechange_searslag2 best12. ;
       format maxpricechange_wmlag2 best12. ;
       format maxpricechange_HDlag3 best12. ;
       format maxpricechange_searslag3 best12. ;
       format maxpricechange_wmlag3 best12. ;
       format top_salesrank best12. ;
       format bottom_salesrank best12. ;
       format ep_topbrandlag1 best12. ;
       format presto_topbrandlag1 best12. ;
       format hbeach_topbrandlag1 best12. ;
       format csnart_topbrandlag1 best12. ;
       format secura_topbrandlag1 best12. ;
       format tfal_topbrandlag1 best12. ;
       format ep_bottombrandlag1 best12. ;
       format presto_bottombrandlag1 best12. ;
       format hbeach_bottombrandlag1 best12. ;
       format csnart_bottombrandlag1 best12. ;
       format secura_bottombrandlag1 best12. ;
       format tfal_bottombrandlag1 best12. ;
       format incr5per_amzn_csnart best12. ;
       format decr5per_amzn_csnart best12. ;
       format incr10per_amzn_csnart best12. ;
       format decr10per_amzn_csnart best12. ;
       format incr20per_amzn_csnart best12. ;
       format decr20per_amzn_csnart best12. ;
       format incr5per_clust1_csnart best12. ;
       format incr5per_clust3_csnart best12. ;
       format incr5per_clust5_tfal best12. ;
       format decr5per_clust1_csnart best12. ;
       format decr5per_clust3_csnart best12. ;
       format decr5per_clust5_tfal best12. ;
       format incr10per_clust1_csnart best12. ;
       format incr10per_clust3_csnart best12. ;
       format incr10per_clust5_tfal best12. ;
       format decr10per_clust1_csnart best12. ;
       format decr10per_clust3_csnart best12. ;
       format decr10per_clust5_tfal best12. ;
       format incr20per_clust1_csnart best12. ;
       format incr20per_clust3_csnart best12. ;
       format incr20per_clust5_tfal best12. ;
       format decr20per_clust1_csnart best12. ;
       format decr20per_clust3_csnart best12. ;
       format decr20per_clust5_tfal best12. ;
       format incr5per_amzn_hbeach best12. ;
       format decr5per_amzn_hbeach best12. ;
       format incr10per_amzn_hbeach best12. ;
       format decr10per_amzn_hbeach best12. ;
       format incr20per_amzn_hbeach best12. ;
       format decr20per_amzn_hbeach best12. ;
       format incr5per_amzn_presto best12. ;
       format decr5per_amzn_presto best12. ;
       format incr10per_amzn_presto best12. ;
       format decr10per_amzn_presto best12. ;
       format incr20per_amzn_presto best12. ;
       format decr20per_amzn_presto best12. ;
       format incr5per_amzn_tfal best12. ;
       format decr5per_amzn_tfal best12. ;
       format incr10per_amzn_tfal best12. ;
       format decr10per_amzn_tfal best12. ;
       format incr20per_amzn_tfal best12. ;
       format decr20per_amzn_tfal best12. ;
       format incr5per_3p_tfal best12. ;
       format decr5per_3p_tfal best12. ;
       format incr10per_3p_tfal best12. ;
       format decr10per_3p_tfal best12. ;
       format incr20per_3p_tfal best12. ;
       format decr20per_3p_tfal best12. ;
       format incr5per_3p_sec best12. ;
       format decr5per_3p_sec best12. ;
       format incr10per_3p_sec best12. ;
       format decr10per_3p_sec best12. ;
       format incr20per_3p_sec best12. ;
       format decr20per_3p_sec best12. ;
    input
                TIME
                Y_amzn_csnart_lag1
                Y_amzn_csnart_lag2
                Y_amzn_csnart_lag3
                Y_amzn_hbeach_lag1
                Y_amzn_hbeach_lag2
                Y_amzn_hbeach_lag3
                Y_amzn_presto_lag1
                Y_amzn_presto_lag2
                Y_amzn_presto_lag3
                Y_amzn_tfal_lag1
                Y_amzn_tfal_lag2
                Y_amzn_tfal_lag3
                Y_clust1_csnart_lag1
                Y_clust1_csnart_lag2
                Y_clust1_csnart_lag3
                Y_clust2_tfal_lag1
                Y_clust2_tfal_lag2
                Y_clust2_tfal_lag3
                Y_clust3_csnart_lag1
                Y_clust3_csnart_lag2
                Y_clust3_csnart_lag3
                Y_clust4_secura_lag1
                Y_clust4_secura_lag2
                Y_clust4_secura_lag3
                Y_clust5_tfal_lag1
                Y_clust5_tfal_lag2
                Y_clust5_tfal_lag3
                Answered_QuestionsEP_lag1
                Answered_QuestionsHbeach_lag1
                Answered_Questionscsnart_lag1
                Answered_Questionssecura_lag1
                Answered_Questionstfal_lag1
                FBA_used3p_lag1
                Freeship_amzn_lag1
                Freeship_used3p_lag1
                Freeship_usedamzn_lag1
                nonbbox3pprice_EP_lag
                nonbbox3pprice_Hbeach_lag
                nonbbox3pprice_csnart_lag
                nonbbox3pprice_secura_lag
                nonbbox3pprice_tfal_lag
                NUM_SELLERSamzn_lag1
                NUM_SELLERSclust1_lag1
                NUM_SELLERSclust2_lag1
                NUM_SELLERSclust3_lag1
                NUM_SELLERSclust4_lag1
                NUM_SELLERSclust5_lag1
                NUM_SELLERSused3p_lag1
                NUM_SELLERSusedamzn_lag1
                NUM_SKUSamzn_lag1
                NUM_SKUSclust1_lag1
                NUM_SKUSclust2_lag1
                NUM_SKUSclust3_lag1
                NUM_SKUSclust4_lag1
                NUM_SKUSclust5_lag1
                NUM_SKUSused3p_lag1
                NUM_SKUSusedamzn_lag1
                NUM_prestoamzn_lag1
                NUM_prestoclust1_lag1
                NUM_prestoclust2_lag1
                NUM_prestoclust3_lag1
                NUM_prestoclust4_lag1
                NUM_prestoclust5_lag1
                NUM_prestoused3p_lag1
                NUM_prestousedamzn_lag1
                Product_reviews_EP_lag1
                Product_reviews_Hbeach_lag1
                Product_reviews_csnart_lag1
                Product_reviews_secura_lag1
                Product_reviews_tfal_lag1
                salerank_EP_lag1
                salerank_Hbeach_lag1
                salerank_csnart_lag1
                salerank_secura_lag1
                salerank_tfal_lag1
                saleranksubcat_EP_lag1
                saleranksubcat_Hbeach_lag1
                saleranksubcat_csnart_lag1
                saleranksubcat_secura_lag1
                saleranksubcat_tfal_lag1
                buyboxprice_EP_lag1
                buyboxprice_Hbeach_lag1
                buyboxprice_csnart_lag1
                buyboxprice_secura_lag1
                buyboxprice_tfal_lag1
                cumsalefreq_amzn_lag1
                max_Product_reviews_presto_lag1
                max_ans_questions_presto_lag1
                max_buyboxprice_presto_lag1
                max_cumsalefreq_clust1_lag1
                max_cumsalefreq_clust2_lag1
                max_cumsalefreq_clust3_lag1
                max_cumsalefreq_clust4_lag1
                max_cumsalefreq_clust5_lag1
                maxnumsellerrate_clust1_lag1
                maxnumsellerate_clust2_lag1
                maxnumsellerate_clust3_lag1
                maxnumsellerate_clust4_lag1
                maxnumsellerate_clust5_lag1
                maxpercsellerate_clust1_lag1
                maxpercsellerate_clust2_lag1
                maxpercsellerate_clust3_lag1
                maxpercsellerate_clust4_lag1
                maxpercsellerate_clust5_lag1
                maxprodstar_presto_lag1
                maxsalerank_presto_lag1
                maxsaleranksubcat_presto_lag1
                maxsellerstar_clust1_lag1
                maxsellerstar_clust2_lag1
                maxsellerstar_clust3_lag1
                maxsellerstar_clust4_lag1
                maxsellerstar_clust5_lag1
                max_uniq_ASIN_clust1_lag1
                max_uniq_ASIN_clust2_lag1
                max_uniq_ASIN_clust3_lag1
                max_uniq_ASIN_clust4_lag1
                max_uniq_ASIN_clust5_lag1
                mean_Product_reviews_presto_lag1
                mean_ans_questions_presto_lag1
                mean_buyboxprice_presto_lag1
                mean_nonbbox3p_presto_lag
                mean_cumsalefreq_clust1_lag1
                mean_cumsalefreq_clust2_lag1
                mean_cumsalefreq_clust3_lag1
                mean_cumsalefreq_clust4_lag1
                mean_cumsalefreq_clust5_lag1
                meannumsellerate_clust1_lag1
                meannumsellerate_clust2_lag1
                meannumsellerate_clust3_lag1
                meannumsellerate_clust4_lag1
                meannumsellerate_clust5_lag1
                meanpercsellerate_clust1_lag1
                meanpercsellerate_clust2_lag1
                meanpercsellerate_clust3_lag1
                meanpercsellerate_clust4_lag1
                meanpercsellerate_clust5_lag1
                meanprodstar_presto_lag1
                meansalerank_presto_lag1
                meansaleranksubcat_presto_lag1
                meansellerstar_clust1_lag1
                meansellerstar_clust2_lag1
                meansellerstar_clust3_lag1
                meansellerstar_clust4_lag1
                meansellerstar_clust5_lag1
                mean_uniq_ASIN_clust1_lag1
                mean_uniq_ASIN_clust2_lag1
                mean_uniq_ASIN_clust3_lag1
                mean_uniq_ASIN_clust4_lag1
                mean_uniq_ASIN_clust5_lag1
                min_Product_reviews_presto_lag1
                min_ans_questions_presto_lag1
                min_buyboxprice_presto_lag1
                min_cumsalefreq_clust1_lag1
                min_cumsalefreq_clust2_lag1
                min_cumsalefreq_clust3_lag1
                min_cumsalefreq_clust4_lag1
                min_cumsalefreq_clust5_lag1
                minnumsellerate_clust1_lag1
                minnumsellerate_clust2_lag1
                minnumsellerate_clust3_lag1
                minnumsellerate_clust4_lag1
                minnumsellerate_clust5_lag1
                minpercsellerate_clust1_lag1
                minpercsellerate_clust2_lag1
                minpercsellerate_clust3_lag1
                minpercsellerate_clust4_lag1
                minpercsellerate_clust5_lag1
                minproductstar_presto_lag1
                minsalerank_presto_lag1
                minsaleranksubcat_presto_lag1
                minsellerstar_clust1_lag1
                minsellerstar_clust2_lag1
                minsellerstar_clust3_lag1
                minsellerstar_clust4_lag1
                minsellerstar_clust5_lag1
                min_uniq_ASIN_clust1_lag1
                min_uniq_ASIN_clust2_lag1
                min_uniq_ASIN_clust3_lag1
                min_uniq_ASIN_clust4_lag1
                min_uniq_ASIN_clust5_lag1
                num_EPamzn_lag1
                num_EPclust1_lag1
                num_EPclust2_lag1
                num_EPclust3_lag1
                num_EPclust4_lag1
                num_EPclust5_lag1
                num_EPused3p_lag1
                num_EPusedamzn_lag1
                num_FBA_clust1_lag1
                num_FBA_clust2_lag1
                num_FBA_clust3_lag1
                num_FBA_clust4_lag1
                num_FBA_clust5_lag1
                num_Freeship_clust1_lag1
                num_Freeship_clust2_lag1
                num_Freeship_clust3_lag1
                num_Freeship_clust4_lag1
                num_Freeship_clust5_lag1
                num_HBeachamzn_lag1
                num_HBeachclust1_lag1
                num_HBeachclust2_lag1
                num_HBeachclust3_lag1
                num_HBeachclust4_lag1
                num_HBeachclust5_lag1
                num_HBeachused3p_lag1
                num_HBeachusedamzn_lag1
                num_csnartamzn_lag1
                num_csnartclust1_lag1
                num_csnartclust2_lag1
                num_csnartclust3_lag1
                num_csnartclust4_lag1
                num_csnartclust5_lag1
                num_csnartused3p_lag1
                num_csnartusedamzn_lag1
                pricechangeEPamzn_lag1
                pricechangeEPclust1_lag1
                pricechangeEPclust2_lag1
                pricechangeEPclust3_lag1
                pricechangeEPclust4_lag1
                pricechangeEPclust5_lag1
                pricechangeEPused3p_lag1
                pricechangeEPusedamzn_lag1
                pricechangeHbeachamzn_lag1
                pricechangeHbeachclust1_lag1
                pricechangeHbeachclust2_lag1
                pricechangeHbeachclust3_lag1
                pricechangeHbeachclust4_lag1
                pricechangeHbeachclust5_lag1
                pricechangeHbeachused3p_lag1
                pricechangeHbeachusedamzn_lag1
                pricechangecsnartamzn_lag1
                pricechangecsnartclust1_lag1
                pricechangecsnartclust2_lag1
                pricechangecsnartclust3_lag1
                pricechangecsnartclust4_lag1
                pricechangecsnartclust5_lag1
                pricechangecsnartused3p_lag1
                pricechangecsnartusedamzn_lag1
                pricechangeprestoamzn_lag1
                pricechangeprestoclust1_lag1
                pricechangeprestoclust2_lag1
                pricechangeprestoclust3_lag1
                pricechangeprestoclust4_lag1
                pricechangeprestoclust5_lag1
                pricechangeprestoused3p_lag1
                pricechangeprestousedamzn_lag1
                pricechangesecuraamzn_lag1
                pricechangesecuraclust1_lag1
                pricechangesecuraclust2_lag1
                pricechangesecuraclust3_lag1
                pricechangesecuraclust4_lag1
                pricechangesecuraclust5_lag1
                pricechangesecuraused3p_lag1
                pricechangesecurausedamzn_lag1
                pricechangetfalamzn_lag1
                pricechangetfalclust1_lag1
                pricechangetfalclust2_lag1
                pricechangetfalclust3_lag1
                pricechangetfalclust4_lag1
                pricechangetfalclust5_lag1
                pricechangetfalused3p_lag1
                pricechangetfalusedamzn_lag1
                num_securaamzn_lag1
                num_securaclust1_lag1
                num_securaclust2_lag1
                num_securaclust3_lag1
                num_securaclust4_lag1
                num_securaclust5_lag1
                num_securaused3p_lag1
                num_securausedamzn_lag1
                num_tfalamzn_lag1
                num_tfalclust1_lag1
                num_tfalclust2_lag1
                num_tfalclust3_lag1
                num_tfalclust4_lag1
                num_tfalclust5_lag1
                num_tfalused3p_lag1
                num_tfalusedamzn_lag1
                priceAmzn_Hbeach_lag
                priceAmzn_csnart_lag
                priceAmzn_presto_lag
                priceAmzn_tfal_lag
                priceclust1_csnart_lag  
                priceclust2_tfal_lag  
                priceclust3_csnart_lag
                priceclust4_secura_lag
                priceclust5_tfal_lag  
                pricedifflowst_AmznHbeach_lag
                pricedifflowst_Amzncsnart_lag
                pricedifflowst_Amznpresto_lag
                pricedifflowst_Amzntfal_lag
                pricedifflowst_clust1csnart_lag  
                pricedifflowst_clust2tfal_lag  
                pricedifflowst_clust3csn_lag
                pricedifflowst_clust4sec_lag
                pricedifflowst_clust5tfal_lag  
                productstar_EP_lag1
                productstar_Hbeach_lag1
                productstar_csnart_lag1
                productstar_secura_lag1
                productstar_tfal_lag1
                time1
                priceAmzn_tfal
                pricediff_lowst_Amzn_tfal
                Y_amzn_tfal
                priceAmzn_Hbeach
                pricediff_lowst_Amzn_Hbeach
                Y_amzn_hbeach
                priceAmzn_presto
                pricediff_lowst_Amzn_presto
                Y_amzn_presto
                priceAmzn_csnart
                pricediff_lowst_Amzn_csnart
                Y_amzn_csnart
                priceclust1_csnart  
                pricediff_lowst_clust1_csnart  
                Y_clust1_csnart
                priceclust2_tfal  
                pricediff_lowst_clust2_tfal  
                Y_clust2_tfal
                priceclust3_csnart
                pricediff_lowst_clust3_csnart
                Y_clust3_csnart
                priceclust4_secura
                pricediff_lowst_clust4_secura
                Y_clust4_secura
                priceclust5_tfal  
                pricediff_lowst_clust5_tfal  
                Y_clust5_tfal
                Freeship_amzn
                cumsalefreq_amzn
                Freeship_usedamzn
                FBA_used3p
                Freeship_used3p
                num_FBA_clust1
                num_Freeship_clust1
                max_perct_sellerrating_clust1
                mean_perct_sellerrating_clust1
                min_perct_sellerrating_clust1
                max_num_seller_rating_clust1
                mean_num_seller_rating_clust1
                min_num_seller_rating_clust1
                max_seller_star_rating_clust1
                mean_seller_star_rating_clust1
                min_seller_star_rating_clust1
                max_uniq_ASIN_clust1
                mean_uniq_ASIN_clust1
                min_uniq_ASIN_clust1
                max_cumsalefreq_clust1
                mean_cumsalefreq_clust1
                min_cumsalefreq_clust1
                num_FBA_clust2
                num_Freeship_clust2
                max_perct_sellerrating_clust2
                mean_perct_sellerrating_clust2
                min_perct_sellerrating_clust2
                max_num_seller_rating_clust2
                mean_num_seller_rating_clust2
                min_num_seller_rating_clust2
                max_seller_star_rating_clust2
                mean_seller_star_rating_clust2
                min_seller_star_rating_clust2
                max_uniq_ASIN_clust2
                mean_uniq_ASIN_clust2
                min_uniq_ASIN_clust2
                max_cumsalefreq_clust2
                mean_cumsalefreq_clust2
                min_cumsalefreq_clust2
                num_FBA_clust3
                num_Freeship_clust3
                max_perct_sellerrating_clust3
                mean_perct_sellerrating_clust3
                min_perct_sellerrating_clust3
                max_num_seller_rating_clust3
                mean_num_seller_rating_clust3
                min_num_seller_rating_clust3
                max_seller_star_rating_clust3
                mean_seller_star_rating_clust3
                min_seller_star_rating_clust3
                max_uniq_ASIN_clust3
                mean_uniq_ASIN_clust3
                min_uniq_ASIN_clust3
                max_cumsalefreq_clust3
                mean_cumsalefreq_clust3
                min_cumsalefreq_clust3
                num_FBA_clust4
                num_Freeship_clust4
                max_perct_sellerrating_clust4
                mean_perct_sellerrating_clust4
                min_perct_sellerrating_clust4
                max_num_seller_rating_clust4
                mean_num_seller_rating_clust4
                min_num_seller_rating_clust4
                max_seller_star_rating_clust4
                mean_seller_star_rating_clust4
                min_seller_star_rating_clust4
                max_uniq_ASIN_clust4
                mean_uniq_ASIN_clust4
                min_uniq_ASIN_clust4
                max_cumsalefreq_clust4
                mean_cumsalefreq_clust4
                min_cumsalefreq_clust4
                num_FBA_clust5
                num_Freeship_clust5
                max_perct_sellerrating_clust5
                mean_perct_sellerrating_clust5
                min_perct_sellerrating_clust5
                max_num_seller_rating_clust5
                mean_num_seller_rating_clust5
                min_num_seller_rating_clust5
                max_seller_star_rating_clust5
                mean_seller_star_rating_clust5
                min_seller_star_rating_clust5
                max_uniq_ASIN_clust5
                mean_uniq_ASIN_clust5
                min_uniq_ASIN_clust5
                max_cumsalefreq_clust5
                mean_cumsalefreq_clust5
                min_cumsalefreq_clust5
                max_ans_questions_presto
                mean_ans_questions_presto
                min_ans_questions_presto
                max_buyboxprice_presto
                mean_buyboxprice_presto
                min_buyboxprice_presto
                max_nonbbox3pprice_presto
                mean_nonbbox3pprice_presto
                min_nonbbox3pprice_presto
                max_product_star_rate_presto
                mean_product_star_rate_presto
                min_product_star_rate_presto
                max_Product_reviews_presto
                mean_Product_reviews_presto
                min_Product_reviews_presto
                max_salesrank_categ_presto
                mean_salesrank_categ_presto
                min_salesrank_categ_presto
                max_salesrank_subcateg_presto
                mean_salesrank_subcateg_presto
                min_salesrank_subcateg_presto
                NUM_SELLERSused3p
                NUM_SKUSused3p
                NUM_prestoused3p
                num_securaused3p
                num_EPused3p
                num_HBeachused3p
                num_tfalused3p
                num_csnartused3p
                NUM_SELLERSusedamzn
                NUM_SKUSusedamzn
                NUM_prestousedamzn
                num_securausedamzn
                num_EPusedamzn
                num_HBeachusedamzn
                num_tfalusedamzn
                num_csnartusedamzn
                NUM_SELLERSamzn
                NUM_SKUSamzn
                NUM_prestoamzn
                num_securaamzn
                num_EPamzn
                num_HBeachamzn
                num_tfalamzn
                num_csnartamzn
                NUM_SELLERSclust1
                NUM_SKUSclust1
                NUM_prestoclust1
                num_securaclust1
                num_EPclust1
                num_HBeachclust1
                num_tfalclust1
                num_csnartclust1
                NUM_SELLERSclust2
                NUM_SKUSclust2
                NUM_prestoclust2
                num_securaclust2
                num_EPclust2
                num_HBeachclust2
                num_tfalclust2
                num_csnartclust2
                NUM_SELLERSclust3
                NUM_SKUSclust3
                NUM_prestoclust3
                num_securaclust3
                num_EPclust3
                num_HBeachclust3
                num_tfalclust3
                num_csnartclust3
                NUM_SELLERSclust4
                NUM_SKUSclust4
                NUM_prestoclust4
                num_securaclust4
                num_EPclust4
                num_HBeachclust4
                num_tfalclust4
                num_csnartclust4
                NUM_SELLERSclust5
                NUM_SKUSclust5
                NUM_prestoclust5
                num_securaclust5
                num_EPclust5
                num_HBeachclust5
                num_tfalclust5
                num_csnartclust5
                buyboxprice_secura
                product_star_secura
                Sales_Rank_Own_Categ_secura
                Sales_Rank_Sub_categ_secura
                Answered_Questionssecura
                Product_reviews_secura
                nonbbox3pprice_secura
                buyboxprice_EP
                product_star_EP
                Sales_Rank_Own_Categ_EP
                Sales_Rank_Sub_categ_EP
                Answered_QuestionsEP
                Product_reviews_EP
                nonbbox3pprice_EP
                buyboxprice_Hbeach
                product_star_Hbeach
                Sales_Rank_Own_Categ_Hbeach
                Sales_Rank_Sub_categ_Hbeach
                Answered_QuestionsHbeach
                Product_reviews_Hbeach
                nonbbox3pprice_Hbeach
                buyboxprice_tfal
                product_star_tfal
                Sales_Rank_Own_Categ_tfal
                Sales_Rank_Sub_categ_tfal
                Answered_Questionstfal
                Product_reviews_tfal
                nonbbox3pprice_tfal
                buyboxprice_csnart
                product_star_csnart
                Sales_Rank_Own_Categ_csnart
                Sales_Rank_Sub_categ_csnart
                Answered_Questionscsnart
                Product_reviews_csnart
                nonbbox3pprice_csnart
                num_pricechange1prestoused3p
                num_pricechange1prestousedamzn
                num_pricechange1prestoamzn
                num_pricechange1prestoclust1
                num_pricechange1prestoclust2
                num_pricechange1prestoclust3
                num_pricechange1prestoclust4
                num_pricechange1prestoclust5
                num_pricechange1securaused3p
                num_pricechange1securausedamzn
                num_pricechange1securaamzn
                num_pricechange1securaclust1
                num_pricechange1securaclust2
                num_pricechange1securaclust3
                num_pricechange1securaclust4
                num_pricechange1securaclust5
                num_pricechange1EPused3p
                num_pricechange1EPusedamzn
                num_pricechange1EPamzn
                num_pricechange1EPclust1
                num_pricechange1EPclust2
                num_pricechange1EPclust3
                num_pricechange1EPclust4
                num_pricechange1EPclust5
                num_pricechange1Hbeachused3p
                num_pricechange1Hbeachusedamzn
                num_pricechange1Hbeachamzn
                num_pricechange1Hbeachclust1
                num_pricechange1Hbeachclust2
                num_pricechange1Hbeachclust3
                num_pricechange1Hbeachclust4
                num_pricechange1Hbeachclust5
                num_pricechange1tfalused3p
                num_pricechange1tfalusedamzn
                num_pricechange1tfalamzn
                num_pricechange1tfalclust1
                num_pricechange1tfalclust2
                num_pricechange1tfalclust3
                num_pricechange1tfalclust4
                num_pricechange1tfalclust5
                num_pricechange1csnartused3p
                num_pricechange1csnartusedamzn
                num_pricechange1csnartamzn
                num_pricechange1csnartclust1
                num_pricechange1csnartclust2
                num_pricechange1csnartclust3
                num_pricechange1csnartclust4
                num_pricechange1csnartclust5
                season
                mean_pricechange_HD
                maxpricechange_HD
                mean_pricechange_wm
                maxpricechange_wm
                mean_pricechange_sears
                maxpricechange_sears
                ext_site
                day_week
                sunday
                monday
                tuesday
                wednesday
                thursday
                friday
                saturday
                weekend
                maxpricechange_HDlag1
                maxpricechange_searslag1
                maxpricechange_wmlag1
                maxpricechange_HDlag2
                maxpricechange_searslag2
                maxpricechange_wmlag2
                maxpricechange_HDlag3
                maxpricechange_searslag3
                maxpricechange_wmlag3
                top_salesrank
                bottom_salesrank
                ep_topbrandlag1
                presto_topbrandlag1
                hbeach_topbrandlag1
                csnart_topbrandlag1
                secura_topbrandlag1
                tfal_topbrandlag1
                ep_bottombrandlag1
                presto_bottombrandlag1
                hbeach_bottombrandlag1
                csnart_bottombrandlag1
                secura_bottombrandlag1
                tfal_bottombrandlag1
                incr5per_amzn_csnart
                decr5per_amzn_csnart
                incr10per_amzn_csnart
                decr10per_amzn_csnart
                incr20per_amzn_csnart
                decr20per_amzn_csnart
                incr5per_clust1_csnart
                incr5per_clust3_csnart
                incr5per_clust5_tfal
                decr5per_clust1_csnart
                decr5per_clust3_csnart
                decr5per_clust5_tfal
                incr10per_clust1_csnart
                incr10per_clust3_csnart
                incr10per_clust5_tfal
                decr10per_clust1_csnart
                decr10per_clust3_csnart
                decr10per_clust5_tfal
                incr20per_clust1_csnart
                incr20per_clust3_csnart
                incr20per_clust5_tfal
                decr20per_clust1_csnart
                decr20per_clust3_csnart
                decr20per_clust5_tfal
                incr5per_amzn_hbeach
                decr5per_amzn_hbeach
                incr10per_amzn_hbeach
                decr10per_amzn_hbeach
                incr20per_amzn_hbeach
                decr20per_amzn_hbeach
                incr5per_amzn_presto
                decr5per_amzn_presto
                incr10per_amzn_presto
                decr10per_amzn_presto
                incr20per_amzn_presto
                decr20per_amzn_presto
                incr5per_amzn_tfal
                decr5per_amzn_tfal
                incr10per_amzn_tfal
                decr10per_amzn_tfal
                incr20per_amzn_tfal
                decr20per_amzn_tfal
                incr5per_3p_tfal
                decr5per_3p_tfal
                incr10per_3p_tfal
                decr10per_3p_tfal
                incr20per_3p_tfal
                decr20per_3p_tfal
                incr5per_3p_sec
                decr5per_3p_sec
                incr10per_3p_sec
                decr10per_3p_sec
                incr20per_3p_sec
                decr20per_3p_sec
    ;
    if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
    run;


/***cuisinart and tfal as examples**/

	data csn_sales (keep = time1 Sales_Rank_Own_Categ_csnart buyboxprice_csnart buyboxprice_csnart_lag1);
	set FINAL_GAM_MODELDATA;
	where Sales_Rank_Own_Categ_csnart > 0;
	run;


		data tfal_sales (keep = time1 Sales_Rank_Own_Categ_tfal buyboxprice_tfal buyboxprice_tfal_lag1);
	set FINAL_GAM_MODELDATA;
	where Sales_Rank_Own_Categ_tfal > 0;
	run;

	
data totsales_csn;
set csn_sales;
daily_sales_csn = exp(10.82981 - 0.73292*log(Sales_Rank_Own_Categ_csnart)) -1;
RUN;
data totsales_tfal;
set tfal_sales;
daily_sales_tfal = exp(10.82981 - 0.73292*log(Sales_Rank_Own_Categ_tfal)) -1;
RUN;

/**modeling sales as a function of buy box price - current and 1 period lag***/

/***CSN****/
proc reg data = totsales_csn;
model daily_sales_csn = 
buyboxprice_csnart buyboxprice_csnart_lag1
;
run;


/***TFAL****/
proc reg data = totsales_tfal;
model daily_sales_tfal = 
buyboxprice_tfal buyboxprice_tfal_lag1;
run;
quit;
